package cn.dzhang.mybatis.model;

import java.util.List;

import org.apache.ibatis.annotations.Select;

public interface UserMapper
{
	@Select("select * from tbl_user where id=#{id}")
	User findById(int id);

	@Select("select * from tbl_user where username=#{username}")
	List<User> findByUsername(String username);
	
	@Select("select * from tbl_user where expired=true")
	List<User> findAllExpired();
}
